:Base abspread.HLP
:Title Spreadsheet
1 Ability Spreadsheet
2 Getting started
3 What is Spreadsheet?=What_is_Spreadsheet
3 Starting Spreadsheet=Starting_Spreadsheet
3 Parts of the spreadsheet window
4 The spreadsheet window=The_spreadsheet_window
4 The toolbars and formatting bar=The_horizontal_toolbar_and_formatting_bar
4 The formula bar=The_formula_bar
4 Coolbars mode and large buttons=Coolbars_Mode_and_Large_Buttons
3 Moving around
4 Moving around a spreadsheet=Moving_around_a_spreadsheet
4 Going to a particular cell=Going_to_a_particular_cell
3 Cells, ranges, address - the basics
4 Spreadsheet definitions=Spreadsheet_definitions
4 Cells=Cells
4 Cell addresses=Cell_addresses
4 Cell ranges=Cell_ranges
2 Creating a spreadsheet
3 Creating a spreadsheet=Creating_a_spreadsheet
3 Opening an existing spreadsheet=Opening_an_existing_spreadsheet
3 Adding text, numbers and dates
4 Entering information=Entering_information
4 Entering text=Entering_text
4 Entering a long text item=Entering_a_long_text_item
4 Entering values=Entering_values
4 Entering currency values=Entering_currency_values
4 Entering a time=Entering_a_time
4 Entering dates=Entering_dates
4 Entering numbers you don't want to calculate=Entering_numbers_you_don_t_want_to_calculate
2 Formatting the cells
3 Formatting the spreadsheet=Formatting_the_spreadsheet
3 Cell font and style=Cell_font_and_style
3 Using the menus to select cell font and style=Using_the_menus_to_select_cell_font_and_style
3 Cell alignment=Cell_alignment
3 Formatting numbers, dates and currencies
4 Formatting a value=Formatting_a_value
4 Formatting a number=Formatting_a_number
4 Formatting a currency=Formatting_a_currency
4 Formatting a time=Formatting_a_time
4 Formatting a date=Formatting_a_date
4 Formatting a percentage=Formatting_a_percentage
4 Formatting a fraction=Formatting_a_fraction
4 Formatting a scientific number=Formatting_a_scientific_number
4 Formatting a boolean value=Formatting_a_boolean_value
4 Clearing a format=Clearing_a_format
3 Background colors and borders
4 Selecting the background color=Selecting_the_background_color
4 Adding borders=Adding_borders
4 Border colors=Border_colors
4 Removing borders=Removing_borders
3 Protecting the cells - locking and hiding
4 Protecting a spreadsheet=Protecting_a_spreadsheet
4 Unprotecting a spreadsheet=Unprotecting_a_spreadsheet
4 Locking and hiding cells=Locking_and_hiding_cells
3 Row and column sizing
4 Changing column width=Changing_column_width
4 Changing row height=Changing_row_height
2 Copying, moving and filling cells
3 Copying and moving information=Copying_and_moving_information
3 Copying and moving examples
4 From one cell to another cell=From_one_cell_to_another_cell
4 From one range to another range=From_one_range_to_another_range
4 Copying one cell to many other cells=Copying_one_cell_to_many_other_cells
4 Copying many cells to one=Copying_many_cells_to_one
4 Copying many cells to many other cells=Copying_many_cells_to_many_other_cells
3 Copying and moving with drag and drop
4 Drag and drop=Drag_and_Drop
4 Drag and move=Drag_and_Move
4 Drag and copy=Drag_and_Copy
3 Filling cells with data
4 Drag and fill=Drag_and_Fill
4 Filling cells automatically=Filling_cells_automatically
2 Deleting and inserting cells, rows and columns
3 Deleting and inserting cells, rows and columns=Deleting_and_inserting_cells_rows_and_columns
3 Drag and delete=Drag_and_Delete
3 Erasing the contents of a cell=Erasing_the_contents_of_a_cell
3 Inserting rows and columns=Inserting_rows_and_columns
3 Deleting cells, rows and columns=Deleting_cells_rows_and_columns
2 Using formulas
3 Using formulas=Using_formulas
3 What is a formula?=What_is_a_formula
3 Arithmetic operators=Arithmetic_operators
3 How to enter a formula=How_to_enter_a_formula
3 Copying a formula=Copying_a_formula
3 Absolute addresses=Absolute_addresses
3 Clearing formulas=Clearing_formulas
3 Automatic totals=Autosum
3 Calculating current selection=Autocalc
3 Turning recalculation on and off=Auto_calculation
3 Link formulas
4 Linking=Linking
4 One way links=One_way_links
4 Two way or hot links=Two_way_or_hot_links
2 Naming cells and ranges
3 Naming cells=Naming_cells
3 Assigning names=Assigning_names
3 Changing or removing names=Changing_or_removing_names
3 Naming a range of cells=Naming_a_range_of_cells
2 Sorting and searching information
3 Sorting=Sorting
3 Searching=Searching
3 Finding next occurrence=Finding_next_occurrence
3 Finding a formula=Finding_a_formula
3 Replacing=Replacing
3 Replace next occurrence=Replace_next_occurrence
2 Transforming and trransposing ranges
3 Transposing ranges=Transposing_ranges
3 Transforming ranges=Transforming_ranges
2 Pages, titles, headers and footers
3 Page set-up=Page_set_up
3 Headers and footers=Headers_and_footers
3 Adding a header and footer=Adding_a_header_and_footer
3 Freezing sections of a spreadsheet=Freezing_sections_of_a_spreadsheet
3 Splitting a spreadsheet=Splitting_a_spreadsheet
2 Printing
3 Printing=Printing
3 Print preview=Print_preview
3 Print set-up=Print_set_up
3 Printing the spreadsheet=Printing_the_spreadsheet
2 Spell checker and thesaurus
3 Spell-checker and thesaurus=Spell_checker_and_thesaurus
3 Autospell=Autospell
2 Spreadsheet options
3 Setting Spreadsheet options=Setting_Spreadsheet_options
3 General options=General_options
3 Custom lists=Custom_Lists
3 Choosing fonts=Choosing_fonts
3 Choosing background color=Choosing_background_color
2 Chart
3 Chart - introduction=Chart
3 Creating a chart=Creating_a_chart
3 Chart properties
4 Style=Chart_style
4 Gallery of chart styles=Gallery_of_chart_styles
4 More on Scatter charts=More_on_Scatter_charts
4 More on Hi-Low charts=More_on_Hi_Low_charts
4 Data range=Data_range
4 Vertical and horizontal series=Vertical_and_horizontal_series
4 Titles and legends=Titles_and_legends
4 Appearance=Appearance_chart
4 3D view=3D_view
4 Axes=Axes
4 Series attributes=Series_Attributes
3 Editing and printing charts
4 Editing a chart=Editing_a_chart
4 Attached charts=Attached_charts
4 Resizing and moving an embedded chart=Resizing_and_moving_an_embedded_chart
4 Deleting a chart from a spreadsheet=Deleting_a_chart_from_a_spreadsheet
4 Printing a chart=Printing_a_chart